const express = require('express');
const connection = require('../uilit/mysql')

const myRouter=express.Router();
myRouter.post('/gsjjzjk',function(req,res){
  console.log(req.body);
  let sql=`SELECT  * FROM job  WHERE c_id=${req.body.gongsiid}`
  let sql1=`SELECT *FROM company LEFT JOIN industry_category ON company.ind_id=industry_category.ind_id WHERE c_id='${req.body.gongsiid}';`
  
  connection.query(sql1,(err,date)=>{
    if(err){
      console.log(err);
    }else{
      connection.query(sql,(err,date1)=>{
        if(err){
          console.log(err);
        }else{

            res.send({date:date,date1:date1,msg:200})
          }
      })
      }
  })

});
module.exports=myRouter;